from sqlalchemy import String, Integer, Column, Text, Date, Numeric
from sqlalchemy.orm import declarative_base


Base = declarative_base()

class Shipping(Base):
    __tablename__ = 'shipping'

    id = Column(Integer, primary_key=True)
    order_id = Column(String(50))
    price = Column(Numeric(precision=15, scale=3))
    number_of_miles = Column(Integer)
    price_per_mile = Column(Numeric(precision=15, scale=3))
    car_information = Column(Text)
    pick_up_location = Column(String(50))
    delivery_location = Column(Text)
    pick_up_or_after_date = Column(Date)
    desired_delivery_date = Column(Date)
    posted_date = Column(Date)
    company_name = Column(String(100))
    phone_number = Column(String(50))
    hours = Column(String(50))
    rating_in_old_system_percent = Column(Numeric(precision=5, scale=2))
    rating_in_old_system_overall = Column(Integer)
    rating = Column(Numeric(precision=3, scale=2))
    overall_rating = Column(Integer)
    additional_info = Column(Text)
